Introduction to Data Warehouses
Back to Home
01. Course Introduction
02. Lesson Introduction
03. Data Warehouse: Business Perspective
04. Operational vs. Analytical Processes
05. Data Warehouse: Technical Perspective
06. Dimensional Modeling
07. ETL Demo: Step 1 & 2
08. Exercise 1: Step 1 & 2
09. ETL Demo: Step 3
10. Exercise 1: Step 3
11. ETL Demo: Step 4
12. Exercise 1: Step 4
13. ETL Demo: Step 5
14. Exercise 1: Step 5
15. ETL Demo: Step 6
16. Exercise 1: Step 6
17. Exercise Solution 1: 3NF to Star Schema
18. DWH Architecture: Kimball's Bus Architecture
19. DWH Architecture: Independent Data Marts
20. DWH Architecture: CIF
21. DWH Architecture: Hybrid Bus & CIF
22. OLAP Cubes
23. OLAP Cubes: Roll-Up and Drill Down
24. OLAP Cubes: Slice and Dice
25. OLAP Cubes: Query Optimization
26. OLAP Cubes Demo: Slicing & Dicing
27. Exercise 2: Slicing & Dicing
28. OLAP Cubes Demo: Roll-Up
29. Exercise 2: Roll-Up & Drill Down
30. OLAP Cubes Demo: Grouping Sets
31. Exercise 2: Grouping Sets
32. OLAP Cubes Demo: CUBE
33. Exercise 2: CUBE
34. Data Warehouse Technologies
35. Demo: Column format in ROLAP
36. Exercise 3: Column format in ROLAP
Back to Home
25. OLAP Cubes: Query Optimization
L01-04-Part 4 OLAP Cubes- Query Optimization
Next Concept